Purpose

Keep track of status of krypto portfolio over time, based on transactions combined with current price data.

Method

  1. Log into crypto account.
  2. John > Statements & Reports > Get latest annual or monthly stmt.
  3. Retrieve stmt from email. (new format as of 2022, but cols still align)
  4. Go to spreadsheet in Marengo - check most recent transaction date there.
  5. Copy/paste new transactions from activity report.
  6. Copy down formulas in spreadsheet.

Bitcoin

date symb acb price_close diff
2022-05-07 BTC-CAD $48,713.25 $46,335.12 -4.88%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

  • Cdn dollar value
  1. Get latest price data.
  2. Combine with cost data.
  3. Calculate profit and ROI.

Ethereum

date symb acb price_close diff
2022-05-07 ETH-CAD $1,914.50 $3,462.65 80.86%

Transactions & Adjusted Cost Base (Avg Cost)

Price, Costs, Profits

Cardano

date symb acb price_close diff
2022-05-07 ADA-CAD $2.29 $1.00 -56.34%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Polkadot

date symb acb price_close diff
2022-05-07 DOT-CAD $34.31 $18.21 -46.92%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

Litecoin

date symb acb price_close diff
2022-05-07 LTC-CAD $228.96 $124.33 -45.70%

Transactions & Adjusted Cost Base (Avg Cost)

Prices, Costs, Profits

PRICE-COST SMRY

date symb acb price_close diff
2022-05-07 BTC-CAD $48,713.25 $46,335.12 -4.88%
2022-05-07 ETH-CAD $1,914.50 $3,462.65 80.86%
2022-05-07 ADA-CAD $2.29 $1.00 -56.34%
2022-05-07 DOT-CAD $34.31 $18.21 -46.92%
2022-05-07 LTC-CAD $228.96 $124.33 -45.70%

TOTALS - Returns

date currency book_val market_val profit roi
2022-05-07 BTC $3,627 $3,450 (177) -5%
2022-05-07 ETH $7,676 $13,884 6,208 81%
2022-05-07 ADA $7,330 $3,200 (4,129) -56%
2022-05-07 DOT $3,465 $1,839 (1,626) -47%
2022-05-07 LTC $2,305 $1,252 (1,053) -46%
date total_invested total_market_val total_profit total_roi
2022-05-07 $24,403 \(23,625</span> </td> <td style="text-align:right;"> <span>\)-777 -3%